﻿CREATE TABLE [dbo].[ParliamentarianWebLinks] (
    [CPALId]             INT            NOT NULL,
    [FacebookAddress]    NVARCHAR (100) NULL,
    [TwitterAddress]     NVARCHAR (100) NULL,
    [PersonalWebsite]    NVARCHAR (100) NULL,
    [PartyWebsite]       NVARCHAR (100) NULL,
    [EmailVisible]       BIT            NULL,
    [ContactFormVisible] BIT            NULL,
    [Link1Address]       NVARCHAR (200) NULL,
    [Link2Address]       NVARCHAR (200) NULL,
    [Link3Address]       NVARCHAR (200) NULL,
    [Link4Address]       NVARCHAR (200) NULL,
    [Link5Address]       NVARCHAR (200) NULL,
    [Link1Label]         NVARCHAR (200) NULL,
    [Link2Label]         NVARCHAR (200) NULL,
    [Link3Label]         NVARCHAR (200) NULL,
    [Link4Label]         NVARCHAR (200) NULL,
    [Link5Label]         NVARCHAR (200) NULL,
    [ElectionMessage]    NVARCHAR (MAX) NULL,
    [FirstSpeechLink]    NVARCHAR (200) NULL,
    [ShortURL]           NVARCHAR (50)  NULL
);





